package cn.sieis.dao;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import cn.sieis.pojo.Project;

public interface ProjectMapper {
	
	public List<Project> getProjectList(@Param("proName")String proName,@Param("proStatus")Integer proStatus,@Param("proSchool")Integer proSchool,@Param("proContest")Integer proContest,
										@Param("from")Integer currentPageNo, @Param("pageSize")Integer pageSize)throws Exception;

	public int getProjectCount(@Param("proName")String proName,@Param("proStatus")Integer proStatus,@Param("proSchool")Integer proSchool,@Param("proContest")Integer proContest)throws Exception;

	public int addProject(Project project)throws Exception;
	
	public int modify(Project project)throws Exception;
	
	public Project getProjectById(@Param("id")Integer id)throws Exception;
	
	public int deleteProjectById(@Param("id")Integer id)throws Exception;
	
	public List<Project> getProList(@Param("proName")String proName,@Param("proStatus")Integer proStatus,@Param("proSchool")Integer proSchool,@Param("proContest")Integer proContest)throws Exception;

	public List<Project> getProProList()throws Exception;
	
	//ǰ��
	public List<Project> getProjectListF(@Param("proName")String proName,@Param("proSchool")Integer proSchool)throws Exception;
	
	public int sign(Project project)throws Exception; 
}
